BEGIN TRANSACTION AddOffice1
	BEGIN TRY
		INSERT INTO [Office] (OfficeId, Name, Address, CityId, Postcode, PhoneNo, ManagerName)
		VALUES (1, 'Swansea Office', '56 Walter Road, Swansea', 'SA1 9AF', 07769855999, 'James Sully')
		
		COMMIT TRANSACTION AddOffice1;
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddOffice1;
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddOffice2
	BEGIN TRY
		INSERT INTO [Office] (OfficeId, Name, Address, CityId, Postcode, PhoneNo, ManagerName)
		VALUES (2, 'Cardiff Office', '100 High Street, Cardiff', 'CF10 5DF', 07769899921, 'Jonathan Curry')
		
		COMMIT TRANSACTION AddOffice2
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddOffice2
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddOffice3
	BEGIN TRY
		INSERT INTO [Office] (OfficeId, Name, Address, CityId, Postcode, PhoneNo, ManagerName)
		VALUES (3, 'London Office', '95 Wandsorth Rd, London', 'SW8 1RZ', 07763899921, 'Lilly Bernardian')
		
		COMMIT TRANSACTION AddOffice3
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddOffice3
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddOffice4
	BEGIN TRY
		INSERT INTO [Office] (OfficeId, Name, Address, CityId, Postcode, PhoneNo, ManagerName)
		VALUES (4, 'Birmingham Office', '109 Belgrave Middleway, Birmingham', 'B12 0XS', 07769876921, 'Laura Apples')
		
		COMMIT TRANSACTION AddOffice4
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddOffice4
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;